Release 10.1A: OpenEdge Data Management:
Database Administration

Using virtual system tables

Depending on the size and complexity of your database, some online database administration utilities can take a significant amount of time to complete. You can use the _UserStatus virtual system table (VST) to monitor the state of the following administration utilities that can be performed online:

IDXANALYS — Displays information about index blocks.
IDXCOMPACT — Increases space utilization of an index block.
IDXFIX — Detects corrupt indexes and records with a missing or incorrect index.
IDXMOVE — Moves indexes among application data storage areas.
TABLEMOVE — Moves tables among application data storage areas.

For detailed descriptions of each VST, see Chapter 25, " Virtual System Tables."

Example

Using the virtual system table mechanism, you can monitor the status and progress of several database administration utilities.

The following example describes how to use a Progress 4GL routine to monitor all the index move (PROUTIL IDXMOVE) processes being performed:

/* Monitor all "index move" processes every three seconds */ REPEAT:   FOR EACH _UserStatus WHERE _UserStatus-Operation = "Index move":     DISPLAY _UserStatus.   END. PAUSE 3. END.

The following is an equivalent OpenEdge SQL statement to monitor all the index move (PROUTIL IDXMOVE) processes being performed:

SELECT * FROM _UserStatus WHERE _UserStatus-Operation = "Index move";